By |
whole database table extract |
SILVER01HDW 8/10/2015 4:46:49 PM | Hi,
I would like to extract all of the data in the database and analyze it using data mining tools that I have developed.. How do I do that? Thank you!!
Sincerely,
tom
|
Caveat 8/10/2015 10:40:37 PM | Might help..
Try "System Setting" then
JCX File Exports
Then use starterhistory...
this will output a csv or txt file of your whole starter history table..
mike
|
jeff 8/12/2015 2:46:50 PM | Adding to what Caveat posted if I may...
You might want to check out the JCX File Exports Module Only Download Package available on the Silver program downloads page.
Unlike the JCX File Exports Module that came with your initial Silver program install - the JCX File Exports Module Only Download Package will get you the ability to use custom sql expressions to drive your exports.
This will give you complete control over what table data fields (or columns) get written to your export as well complete control over filtering parameters such as [date], track, intsurface, dist, tkcond, fieldsize, paceindex, classdescriptor, rider, trainer, etc.
-jp
.
|
SILVER01HDW 8/12/2015 9:34:10 PM | Thank you!!!
|
SILVER01HDW 8/14/2015 5:01:20 PM | Hi Jeff,
I have looked through most of the messages in the downloads and tech report and cant find the JCX File Exports Module Only Download Package.. Am I looking in the wrong place? Thank you!!
Sincerely,
tom
|
SILVER01HDW 8/14/2015 8:34:35 PM | Hi,
When try to export the starterhistory table that way I get "error-2147217900 Description Syntax error in string in query expression "railposition".. Any ideas on what is going wrong and what I can do? Thank you!!
Sincerely,
tom
|
jeff 8/15/2015 7:53:12 AM | --quote:"I have looked through most of the messages in the downloads and tech report and cant find the JCX File Exports Module Only Download Package.. Am I looking in the wrong place? Thank you!!" --end quote
Log into the message board. Then goto the Downloads & Tech Support forum. From there click the link for the JCapper Program Downloads page (hint: far upper right hand corner.)
Once you are at the JCapper Program Downloads page you should see the download and release notes links for the JCX File Exports Module Only Special Download Package.
Link to screenshot: http://www.JCapper.com/MessageBoard/Avatars/SilverProgramDownloadsPage08142015.jpg
Read the release notes for instructions. Then download and install.
-jp
.
|
jeff 8/15/2015 8:02:10 AM | --quote:"When try to export the starterhistory table that way I get "error -2147217900 Description Syntax error in string in query expression "railposition".. Any ideas on what is going wrong and what I can do? Thank you!!" --end quote
An error code beginning with the characters "-214" indicates the sql expression you are trying to execute is invalid in some way.
Try posting the sql expression here or emailing it to me - and I'll have a look.
jeff @ jcapper . com (remove the blank spaces first)
-jp
.
|